How To Setup The Database:

1. Create a new database called "CommunityServer"
2. Grant your login access to the new database.
	2a. If you're using Windows Authentication. Enable Integrated Security (you can run the user.sql file, 
		only recommended for development/test machines)
	2b. If you're using Sql Authentication, use Enterprise Manager to grant your SQL Login access to the 
		new database.
		
	- Note: At a minimum, Community Server will required the following database roles:
		db_securityadmin
		db_ddladmin
		db_datareader
		db_datawriter
		
3. Execute InstallCommon.sql
4. Execute InstallMembership.sql
5. Execute InstallProfile.sql
6. Execute InstallRole.sql
7. Execute cs_Schema.sql
8. Execute cs_Default.sql
9. Execute cs_Procedures.sql
10. Execute exec cs_system_createcommunity 'localhost/cs', 'dev', 'admin', null, 1
The default admin credentials are:
UserName: Admin
Password: Pa$$word


OR:

Simply browse to where you installed CS and view /installer and walk through the integrated installer. Please note, the installer will not do updates and should be deleted when not being used.


Upgrading From Beta 3 (Beta3_TO_RC2 Folder)
- Run beta_3_RC.sql
- Run cs_Procedures.sql

Upgrading From RC1 to RC2 (RC_1_TO_R2 Folder)
- Execute both sprocs

Upgrading From RC2 to RC3
- Execute cs_Procedures

Upgrading RC3 to RTM
- NO DB Chanages

If you are ugrading from Community Server Beta 3, you may use thbe beta_3_to_RC.sql script. Please test this on a backup first. It is an autogenerated file and not well tested. Once completed, you will need to run the cs_Prodcedures.sql file.

If you would like to enable integrated security, plase see the user.sql script.


